<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Simple statistics</title>
<link type="text/css" href="style.css" rel="stylesheet"></link>
</head>
<body>
	<h1>Simple statistics</h1>
	<hr>
	   
	They provide simple statistics on the number of records. 
	<p>
	It gives an overview of the content of the column, how many null data there is, how many distinct data...
	<p>
	
	<ul>
		<li>Blank Count: counts the number of blank rows. A "blank" is a non null textual data that contains only white space. Note that Oracle does not distinguish between the empty string and the null value.</li>
		<p>
	    <li>Default Value Count: counts the number of default values.</li>
		<p>
	    <li>Distinct Count: counts the number of distinct values of your column.</li>
		<p>
	    <li>Duplicate Count: counts the number of values appearing more than once. You have the relation: Duplicate count + Unique count = Distinct count.</li>
		<p>
	    <li>Null Count: counts the number of null rows.</li>
		<p>
	    <li>Row Count: counts the number of rows.</li>
		<p>
	    <li>Unique Count: counts the number of distinct values with only one occurrence. It is necessarily less or equal to Distinct counts.</li>
    </ul>
    
	<p>
	For example, a,a,a,a,b,b,c,d,e => 9 values, 5 distinct values, 3 unique values, 2 duplicate values.	
	<p>
	
	<iframe align="top" frameborder="0" scrolling="no" id="footer" src="footer.html"></iframe>
	
</body>
</html>